connstr ="Provider=SQLOLEDB;DATA SOURCE=59.68.131.78;" & _ "Password=password;" & _

来源：百度知道 编辑：UC知道 时间：2024/09/24 01:23:46
我做的毕业设计是ASP连接SQL SERVER2000
连接的时候先是连接不上
后来改了代码以后可以连了但是出现错误
望高手指教
代码如下
<%
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr ="Provider=SQLOLEDB.1;DATA SOURCE=59.68.131.78;" & _ "Password=password;" & _
"User ID=sa;" & _
"DATABASE=tssgajzbc;"
conn.Open connstr

%>

提示错误如下
错误类型：
Microsoft VBScript 编译器错误 (0x800A0408)
无效字符
/qiye_2/conn.asp, line 5, column 59
connstr ="Provider=SQLOLEDB;DATA SOURCE=59.68.131.78;" & _ "Password=password;" & _
按照这个改了以后
<%
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr ="Provider=SQLOLEDB.1;DATA SOURCE=localhost;Password=password;User ID=username;Initial Catalog =databasename;"
conn.Open connstr

%>
出现这样的错误，头都大了！！！
Microsof

<%
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr ="Provider=SQLOLEDB.1;DATA SOURCE=localhost;Password=password;User ID=username;Initial Catalog =databasename;"
conn.Open connstr

%>
给你个参考.

"Provider=SQLOLEDB.1;User ID=sa;Password=password;Data Source=59.68.131.78;Initial Catalog=tssgajzbc"